﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.OleDb;
using System.Data;
using DTO;
namespace DAL
{
    public class HocSinh_DAL
    {
        static object MaLop;
        static OleDbConnection KN;
        public static void LayDuLieuCmb(Object Ma)
        {
            MaLop = Ma;
        }
        public static DataTable LoadDSHS()
        {
            string sChuoiTruyVan = String.Format("Select * from SinhVien");
            //Mo ket noi;
            KN = DataProvider.KetNoi();
            //Lay du lieu tu csdl do vao datatable
            DataTable dtDSHS = DataProvider.LayDuLieuDataTable(sChuoiTruyVan, KN);
            //Ngat Ket noi
            DataProvider.DongKetNoi(KN);
            return dtDSHS;
        }
    }
}
